﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace QuanLiNhaSachDAO
{
    public class ReportViewerDAO
    {
        public static DataTable ViewHoaDon()
        {
            string sql = "select Sach.id as MaSach,Sach.Ten as Ten,NhaXuatBan.Ten as NhaXuatBan,ChiTietHoaDon.SoLuong, GiaBan as DonGia,[GiaBan * HoaDon.SoLuong] AS ThanhTien from SACH, HOADON, CHITIETHOADON, NHAXUATBAN " + 
                "where ";
            SqlDataAdapter sda = new SqlDataAdapter(sql, sqlDB.MyConnection);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            return dt;      
        }


    }
}
